Released on: March 5, 2008, 4:10 pm

Press Release Author: aspose_seo

Industry: Software

Press Release Summary: Aspose publishes March 2008 Newsletter with focus on new and
improved features by Aspose.Flash, Aspose.Words, Aspose.Pdf, Aspose.Cells and
Aspose.BarCode along with a Technical-Tip about how you can insert / delete rows in
an Excel worksheet?

Press Release Body: Welcome to the March 2008 issue of the Aspose Newsletter! In
this month's newsletter, we will provide some introductory information about our
spotlight product: Aspose.ASPXpand. We will also look at the new and exciting
features offered in the recent releases of Aspose.Words, Aspose.Pdf, Aspose.Cells,
Aspose.BarCode and Aspose.Workflow. You will learn about the latest news from Aspose
along with the monthly Tech-Tip, which demonstrates how you can insert / delete rows
in an Excel worksheet.

Product Spotlight

Microsoft® did a wonderful job of marrying web development to a design environment
that desktop programmers could embrace. However, the web environment lacks many of
the features that so appealed to desktop developers. Aspose.ASPXpand helps bridge
the gap between web and desktop development. Aspose.ASPXpand offers over 60
different functions ranging from Set Focus and Mask Edit to Auto Complete and
handling the Enter Key. Aspose.ASPXpand works with all of the native web objects
supplied with ASP.NET, making Aspose.ASPXpand easy to add to new code or existing
code. Take the time to download the free evaluation version today to see how
Aspose.Flash can work for you.

Aspose.Words for .NET 5.0.2.0 released

Earlier this month Aspose.Words for .NET 5.0.0.0 was released. With this release the
support for Office Open XML documents officially came out of beta. This release also
includes beta support for saving in Open Document Format (ODT). This release was
soon followed by the 5.0.1.0 and 5.0.2.0 releases. These two releases contained
numerous improvements and fixes for bugs present in the first release. For more
information about the enhancements presented in these releases you are requested to
visit their official release pages at here, here and here. The latest version
5.0.2.0 of Aspose.Words for .NET can be downloaded from here.

Aspose.Pdf for .NET back in action

After an absence of almost 3 months, a new hot fix for Aspose.Pdf for .NET has been
released. The latest version 3.6.2.0 of Aspose.Pdf for .NET includes support for a
new overloaded version of BindFO method, which accepts streams, and support for
authentication when binding to HTML. This release also supports local hyperlink for
table cells and data formatting in ImportDataTable and ImportDataView. In addition
to this, also included are many improvements and numerous bug fixes. The latest
version can be downloaded from here. For more details, please visit its official
release page.

Exciting new demo and articles for Aspose.Words

We have published an interesting demo project that you might find useful. This demo
project uses Aspose.Cells for .NET, Aspose.Words for .NET and about 1200 lines of
custom code to convert Microsoft Excel workbooks to Microsoft Word documents. For
more information please consult the release page. The demo can be downloaded from
here. We also have a great new article about how to use Aspose.Words in a PHP
project. You can use either Aspose.Words for .NET or Aspose.Words for Java. The
article discusses pros and cons of both approaches and shows essential techniques.
For more information please visit the release page. The article is available here.

File type auto-detection in Aspose.Cells for .NET

The latest release of Aspose.Cells for .NET version 4.4.1.0 comes with the ability
to automatically detect the file type when opening an Excel file. In addition to
this the support for Excel2007 XLSX has been enhanced and XLS2PDF feature has been
improved in this release. The release also comes with enhanced pivot table support
and more functions in formula calculation engine. You will also find many
improvements and numerous bug fixes in this release. For more information please
consult the official release page. The latest version of Aspose.Cells for .NET can
be downloaded from here.

USPS OneCode barcode recognition with Aspose.BarCode for .NET

The latest release of Aspose.BarCode for .NET version 2.4.1.0 supports recognizing
USPS OneCode barcode images, which makes Aspose.BarCode for .NET the first barcode
recognition component in the market to have this feature. Aspose.BarCode can now
recognize more than 22 barcode standards including both 1D barcodes and 2D barcodes.
Numerous other improvements and bug fixes have also been included in this release.
For more information please visit the official release page. Please download this
latest release from here.

Aspose.Cells for Java 1.9.3.0 released

We have released Aspose.Cells for Java version 1.9.3.0. Included in this version is
the support for adding Arc, Oval, and Rectangle to Excel files; as well as adding
Word and Excel file as OLE object. Now you can copy the style when inserting rows
and columns, get number format type of cell and filter non-blank/blank cells in
AutoFilter. Also included in this release are numerous bug fixes and improvements.
Please visit the official release page for more information. You can download the
latest version of Aspose.Cells for Java from here.

Aspose.Workflow for .NET optimized for .NET 2.0

Aspose.Workflow for .NET version 1.3.0.0 has been released. Aspose.Workflow is a
distinct .NET based component that is used to manage workflow applications in order
to automate business processes. The latest release has been optimized for the .NET
2.0 Framework. Also included in this release are updated samples for .NET 1.x and
.NET 2.0 as well as updated help documents. Numerous bug fixes and improvements have
also been incorporated into this release. For more information please visit the
release page. The latest version is available for download from here.

Technical Tip - Insert / Delete rows in an Excel Worksheet

Do you wish to have worksheets that can be easily updated to keep up with your
constantly changing business needs? Using Aspose.Cells APIs, you can quickly insert
new rows, columns, cells, and worksheets - and just as easily delete them - calling
a few methods only and your task is performed with excellence. While you are
creating a new worksheet from scratch or working with an existing worksheet, you
might need to add extra rows / columns into your worksheet to accommodate more data
or for your specific need. Alternatively, it can also be required to delete rows /
columns from specified positions / locations in the worksheet. To fulfill these
requirements, Aspose.Cells provides simplest set of APIs that can easily perform
your desired task within no time. There are two methods that Aspose.Cells offers in
this regard i.e., InsertRows and DeleteRows, these two methods are optimized related
performance and efficient enough to do the job very quickly.

So if you are in need to insert some sets of rows or remove a number of rows, it is
recommended that you should always use InsertRows and DeleteRows methods instead of
repeatedly using InsertRow and DeleteRow methods in a loop.

Aspose.Cells works in the same way as MS Excel does. When rows or columns are added,
the contents in the worksheet are shifted to downwards or right side but if rows or
columns are removed, the contents in the worksheet will be shifted to upwards or
left side. Moreover, the references in other worksheets are updated accordingly upon
insertion / deletion of rows.

Following example shows the usage of InsertRows and DeleteRows methods

[C#]

//Instantiate a Workbook object.
Workbook workbook = new Workbook();
//Load a template file.
workbook.Open(\"d:\\\\test\\\\MyBook.xls\");
//Get the first worksheet in the book.
Worksheet sheet = workbook.Worksheets[0];
//Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.Cells.InsertRows(2, 10);
//Delete 5 rows now. (8th row - 12th row)
sheet.Cells.DeleteRows(7, 5);
//Save the excel file.
workbook.Save(\"d:\\\\test\\\\out_MyBook.xls\");

[VB]

\'Instantiate a Workbook object.
Dim workbook As Workbook = New Workbook
\'Load a template file.
workbook.Open(\"d:\\test\\MyBook.xls\")
\'Get the first worksheet in the book.
Dim sheet As Worksheet = workbook.Worksheets(0)
\'Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.Cells.InsertRows(2, 10)
\'Delete 5 rows now. (8th row - 12th row)
sheet.Cells.DeleteRows(7, 5)
\'Save the excel file.
workbook.Save(\"d:\\test\\out_MyBook.xls\")

[Java]

//Instantiate a Workbook object.
Workbook workbook = new Workbook();
//Load a template file.
workbook.open(\"d:\\\\test\\\\MyBook.xls\");
//Get the first worksheet in the book.
Worksheet sheet = workbook.getWorksheets().getSheet(0);
//Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.getCells().insertRows(2, 10);
//Delete 5 rows now. (8th row - 12th row)
sheet.getCells().deleteRows(7, 5,true);
//Save the excel file.
workbook.save(\"d:\\\\test\\\\out_MyBook.xls\");

Web Site:
http://www.aspose.com/community/blogs/customer.newsletters/archive/2008/03/01/aspose-customer-newsletter-march-2008.aspx


Contact Details: Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465l